package org.jeecg.modules.land.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.land.entity.TbAssetManagement;

import java.util.List;

/**
 * @Description: 无形资产-土地使用权明细
 */
public interface TbAssetManagementMapper extends BaseMapper<TbAssetManagement> {
//    @Select("select * from tb_asset_management  ORDER BY SUBSTRING(code, 1, 6) ASC, LENGTH(code) ASC, code ASC")
    List<TbAssetManagement> selectAllCodeASC(TbAssetManagement tbAssetManagement);

    List<TbAssetManagement> selectSummerList(TbAssetManagement tbAssetManagement);

    @Select("DELETE FROM tb_asset_management")
    void removeAll();
}
